drop table if exists jms_dim.dim_whole_province_configuration_base;
create external table if not exists jms_dim.dim_whole_province_configuration_base(
    agent_code     string           comment'代理区编码'
   ,agent_name  	 string           comment'代理区名称'
   ,times          decimal(15,2)    comment'平均时长'
) comment '七星潭派签时效'
stored as parquet
location '/dw/hive/jms_dim.db/external/dim_whole_province_configuration_base'
tblproperties (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);

